package com.dykj.fireFighting.server.socialUnit.firemanger.mapper;


import com.dykj.fireFighting.api.socialUnit.firemanger.entity.FireStationDevice;
import com.dykj.fireFighting.common.core.mapper.SuperMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @Description 消防站设备中间表
 * @Author aixiaolan
 * @Date  2021-07-06 08:39:19
 */
public interface FireStationDeviceMapper extends SuperMapper<FireStationDevice> {

    @Select("select device_id from fire_station_device where fire_station_id=#{fireStationId} and type=#{type}" )
    List<String> getFireStationDeviceById(@Param("fireStationId") String fireStationId,@Param("type") Integer type);

    @Delete("DELETE FROM fire_station_device where fire_station_id=#{fireStationId}")
    int delFireStationById(@Param("fireStationId") String fireStationId);

	
}
